CREATE TABLE jms_dm.dm_sqs_abnormal_network_interceptor_detail_dt (
                                                                      province varchar(100) NULL COMMENT "省份",
                                                                      network_name varchar(200) NULL COMMENT "网点名称",
                                                                      province_id varchar(100) NULL COMMENT "省份id",
                                                                      network_code varchar(100) NULL COMMENT "网点编码",
                                                                      abnormal_reason_code varchar(300) NULL COMMENT "筛单原因编码",
                                                                      abnormal_reason varchar(300) NULL COMMENT "筛单原因",
                                                                      effect_time_start date NULL COMMENT "生效日期",
                                                                      effect_time_end date NULL COMMENT "失效日期",
                                                                      date_time date NULL COMMENT "统计时间",
                                                                      virt_code varchar(100) NULL COMMENT "虚拟代理区code",
                                                                      virt_name varchar(200) NULL COMMENT "虚拟代理区name",
                                                                      belong_proxy varchar(100) NULL COMMENT "代理区名称",
                                                                      belong_proxy_code varchar(200) NULL COMMENT "代理区编码"
) ENGINE=OLAP
DUPLICATE KEY(province, network_name)
COMMENT "京津网点异常分析-筛单明细"
PARTITION BY RANGE(date_time)
    START ("2023-02-28") END ("2023-03-05") EVERY (INTERVAL 1 day)
)
DISTRIBUTED BY HASH(network_code) BUCKETS 1
PROPERTIES (
"replication_num" = "3",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-2",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "1",
"in_memory" = "false",
"storage_format" = "V2"
);